{
  "statement": "select\n    count(*) as aggregate\nfrom\n    `crm_activity` as `activity`\n    left join `crm_status` as `status` on `status`.`id` \u003d `activity`.`status`\n    left join `crm_category` as `category` on `category`.`id` \u003d `activity`.`category`\n    left join `crm_activity_dynamic_data` as `activity_dynamic` on `activity_dynamic`.`activity_id` \u003d `activity`.`id`\n    left join `crm_opportunities` as `deal` on `deal`.`id` \u003d `activity`.`opporid`\n    left join `crm_deal_dynamic_data` as `deal_dynamic` on `deal_dynamic`.`oppor_id` \u003d `activity`.`opporid`\n    left join `crm_customer_details` as `customer` on `customer`.`id` \u003d `activity`.`customer_id`\n    left join `crm_customer_dynamic_data` as `customer_dynamic` on `customer_dynamic`.`customer_id` \u003d `activity`.`customer_id`\nwhere\n    `activity`.`parentid` \u003d 1575\n    and activity.seq_no IS NOT NULL\n    and `activity`.`end_datetime` \u003e\u003d 2022 -12 -01\n    and `activity`.`datetime` \u003c\u003d 2022 -12 -31\n    and `activity`.`id` in (\n        select\n            `mapping`.`activity_id` as `id`\n        from\n            `crm_activity_asset_mapping` as `mapping`\n            left join `crm_reference` as `asset` on `asset`.`id` \u003d `mapping`.`asset_id`\n            left join `crm_reference_dynamic_data` as `asset_dynamic` on `asset_dynamic`.`reference_id` \u003d `mapping`.`asset_id`\n        where\n            `asset`.`parentid` \u003d 1575\n            and `asset`.`category` in (46982)\n    )\n    and `activity`.`id` in (\n        select\n            `permission`.`ref_id` as `id`\n        from\n            `crm_user_permissions` as `permission`\n        where\n            `permission`.`parentid` \u003d 1575\n            and (\n                (\n                    `permission`.`type` \u003d \u0027activity\u0027\n                    and `permission`.`current_permission` !\u003d 0\n                    and `permission`.`profileid` \u003d 1575\n                )\n                or (\n                    `permission`.`deal_id` in (\n                        select\n                            `parentpermission`.`ref_id` as `deal_id`\n                        from\n                            `crm_user_permissions` as `parentpermission`\n                        where\n                            `parentpermission`.`parentid` \u003d 1575\n                            and (\n                                `parentpermission`.`type` \u003d \u0027deal\u0027\n                                and `parentpermission`.`current_permission` !\u003d 0\n                                and `parentpermission`.`profileid` \u003d 1575\n                            )\n                    )\n                )\n                or (\n                    `permission`.`customer_id` in (\n                        select\n                            `parentpermission`.`ref_id` as `customer_id`\n                        from\n                            `crm_user_permissions` as `parentpermission`\n                        where\n                            `parentpermission`.`parentid` \u003d 1575\n                            and (\n                                `parentpermission`.`type` \u003d \u0027customer\u0027\n                                and `parentpermission`.`current_permission` !\u003d 0\n                                and `parentpermission`.`profileid` \u003d 1575\n                            )\n                    )\n                )\n            )\n    )\n    and `activity`.`isactive` \u003d 1",
  "table_meta": {
    "staging.crm_activity": "CREATE TABLE `crm_activity` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `opporid_1` varchar(65533) NULL COMMENT \"crm_opportunities.id\",\n  `profileid` varchar(65533) NULL COMMENT \"accounts.id\",\n  `notes` varchar(65533) NULL COMMENT \"\",\n  `datetime` datetime NULL COMMENT \"\",\n  `category_1` varchar(65533) NULL COMMENT \"crm_category.id\",\n  `attachment` varchar(65533) NULL COMMENT \"\",\n  `attachment_backup` varchar(65533) NULL COMMENT \"\",\n  `status_1` varchar(65533) NOT NULL DEFAULT \"6\" COMMENT \"crm_status.id\",\n  `address` varchar(65533) NULL COMMENT \"crm_customer_address.id\",\n  `pic` varchar(65533) NULL COMMENT \"ASSIGNED EDIT USER\",\n  `pic_view` varchar(65533) NULL COMMENT \"ASSIGNED VIEW USER\",\n  `pic_edit` varchar(65533) NULL COMMENT \"NOT USED ANYMORE\",\n  `pic_chosen` varchar(65533) NULL COMMENT \"NOT USED ANYMORE\",\n  `pic_count` varchar(65533) NULL COMMENT \"USED AS A COUNTER TO DETERMINE IF CHECKBOX SHOULD BE GREY, GETS ITS VALUE FROM DEAL AND CUSTOMER\",\n  `alertpic` varchar(65533) NULL COMMENT \"alert activity to user\",\n  `completed_by` varchar(65533) NULL COMMENT \"\",\n  `completed_date` datetime NULL COMMENT \"\",\n  `isactive` int(11) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `ishidden` int(11) NOT NULL DEFAULT \"0\" COMMENT \"\",\n  `update_log` varchar(65533) NULL COMMENT \"no more use\",\n  `refid` varchar(65533) NULL COMMENT \"unique seq no\",\n  `created_date` datetime NULL COMMENT \"\",\n  `lastupdated` datetime NULL COMMENT \"\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `referenceid` varchar(65533) NULL COMMENT \"\",\n  `assign_child` varchar(65533) NULL COMMENT \"\",\n  `end_datetime` datetime NULL COMMENT \"\",\n  `status` bigint(20) NULL COMMENT \"\",\n  `category` bigint(20) NULL COMMENT \"\",\n  `opporid` bigint(20) NULL COMMENT \"\",\n  `datediff_indicator` int(11) NOT NULL DEFAULT \"0\" COMMENT \"\",\n  `status_modification_date` datetime NULL COMMENT \"\",\n  `last_comment_datetime` datetime NULL COMMENT \"\",\n  `last_alert_datetime` datetime NULL COMMENT \"\",\n  `customer_id` bigint(20) NULL COMMENT \"\",\n  `repeat_refid` bigint(20) NULL COMMENT \"\",\n  `source_id` int(11) NULL COMMENT \"\",\n  `source_type` varchar(65533) NULL COMMENT \"\",\n  `unique_comment_categories` varchar(65533) NULL COMMENT \"\",\n  `unique_comment_categories_bk` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 9 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_activity_asset_mapping": "CREATE TABLE `crm_activity_asset_mapping` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `activity_id` int(11) NULL COMMENT \"\",\n  `asset_id` int(11) NULL COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_activity_dynamic_data": "CREATE TABLE `crm_activity_dynamic_data` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `activity_id` int(11) NULL COMMENT \"\",\n  `profile_id` int(11) NULL COMMENT \"\",\n  `customer_id` int(11) NULL COMMENT \"\",\n  `template_id` int(11) NULL COMMENT \"\",\n  `inputTextLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputDateLbl1` date NULL COMMENT \"\",\n  `inputDateLbl2` date NULL COMMENT \"\",\n  `inputDateLbl3` date NULL COMMENT \"\",\n  `inputDateLbl4` date NULL COMMENT \"\",\n  `inputDateLbl5` date NULL COMMENT \"\",\n  `inputDateTimeLbl1` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl2` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl3` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl4` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl5` datetime NULL COMMENT \"\",\n  `inputDropDownLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl3` varchar(65533) NULL COMMENT \"\",\n  `created_by` varchar(65533) NULL COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `modified_by` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_category": "CREATE TABLE `crm_category` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `name` varchar(65533) NOT NULL COMMENT \"\",\n  `type` varchar(65533) NOT NULL COMMENT \"\",\n  `is_active` int(11) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `is_admin` int(11) NOT NULL DEFAULT \"0\" COMMENT \"\",\n  `icon` varchar(65533) NULL COMMENT \"\",\n  `ordershow` int(11) NOT NULL DEFAULT \"2\" COMMENT \"\",\n  `editable` bigint(20) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `ishide` varchar(65533) NULL COMMENT \"\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `sorting` int(11) NULL COMMENT \"\",\n  `code` varchar(65533) NULL COMMENT \"\",\n  `pre_population_fields` varchar(65533) NOT NULL COMMENT \"\",\n  `access_comment_ids` varchar(65533) NULL COMMENT \"\",\n  `access_status_ids` varchar(65533) NULL COMMENT \"\",\n  `parent_category_id` varchar(65533) NULL COMMENT \"\",\n  `type_original` varchar(65533) NULL COMMENT \"\",\n  `access_status_ids_original` varchar(65533) NULL COMMENT \"\",\n  `default_status_id` varchar(65533) NULL COMMENT \"\",\n  `product_migrate_state` int(11) NOT NULL DEFAULT \"0\" COMMENT \"\",\n  `system_hidden` int(11) NOT NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_customer_details": "CREATE TABLE `crm_customer_details` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `contact_id` varchar(65533) NULL COMMENT \"\",\n  `contact_sub_id` varchar(65533) NULL COMMENT \"\",\n  `agent_id` int(11) NULL COMMENT \"accounts.id\",\n  `phone` varchar(65533) NULL COMMENT \"\",\n  `phone_type` varchar(65533) NULL COMMENT \"\",\n  `name` varchar(65533) NULL COMMENT \"\",\n  `company` varchar(65533) NULL COMMENT \"\",\n  `email` varchar(65533) NULL COMMENT \"\",\n  `address` varchar(65533) NULL COMMENT \"\",\n  `reference_code` varchar(65533) NULL COMMENT \"\",\n  `device_name` varchar(65533) NULL COMMENT \"\",\n  `sms_campaign` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `shared_to` varchar(65533) NULL COMMENT \"USED AS A COUNTER TO DETERMINE IF CHECKBOX SHOULD BE GREY, GETS ITS VALUE FROM DEAL AND ACTIVITY\",\n  `full_shared_to` varchar(65533) NOT NULL COMMENT \"ASSIGNED EDIT USER\",\n  `shared_to_view` varchar(65533) NULL COMMENT \"ASSIGNED VIEW USER\",\n  `shared_to_chosen` varchar(65533) NULL COMMENT \"NOT USED\",\n  `isactive` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `isactivenew` int(11) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `phonelist` varchar(65533) NULL COMMENT \"no more use\",\n  `created_date` datetime NULL COMMENT \"\",\n  `lastupdated` datetime NULL COMMENT \"\",\n  `add_data` varchar(65533) NULL COMMENT \"\",\n  `emaillist` varchar(65533) NULL COMMENT \"no more use\",\n  `reference_list` varchar(65533) NULL COMMENT \"crm_reference.id as json format\",\n  `customer_deal_amount` double NOT NULL DEFAULT \"0.00\" COMMENT \"total amt of deal\",\n  `customer_deal_category_list` varchar(65533) NULL COMMENT \"deal category list as string\",\n  `customer_category` varchar(65533) NULL COMMENT \"category list as json format\",\n  `customer_deal_assign` varchar(65533) NULL COMMENT \"no more use\",\n  `customer_deal_view` varchar(65533) NULL COMMENT \"no more use\",\n  `photo` varchar(65533) NULL COMMENT \"\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `assign_child` varchar(65533) NULL COMMENT \"Add grey and assign to all child\",\n  `customer_category_id` bigint(20) NULL COMMENT \"\",\n  `customer_status_id` bigint(20) NULL COMMENT \"\",\n  `default_deal_id` bigint(20) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_customer_dynamic_data": "CREATE TABLE `crm_customer_dynamic_data` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `profile_id` int(11) NULL COMMENT \"\",\n  `customer_id` int(11) NULL COMMENT \"\",\n  `template_id` int(11) NULL COMMENT \"\",\n  `inputTextLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl8` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl9` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl10` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputDateLbl1` date NULL COMMENT \"\",\n  `inputDateLbl2` date NULL COMMENT \"\",\n  `inputDateLbl3` date NULL COMMENT \"\",\n  `inputDateLbl4` date NULL COMMENT \"\",\n  `inputDateLbl5` date NULL COMMENT \"\",\n  `inputDateTimeLbl1` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl2` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl3` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl4` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl5` datetime NULL COMMENT \"\",\n  `inputDropDownLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl3` varchar(65533) NULL COMMENT \"\",\n  `created_by` varchar(65533) NULL COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `modified_by` datetime NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_deal_dynamic_data": "CREATE TABLE `crm_deal_dynamic_data` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `profile_id` int(11) NULL COMMENT \"\",\n  `oppor_id` int(11) NULL COMMENT \"\",\n  `customer_id` int(11) NULL COMMENT \"\",\n  `template_id` int(11) NULL COMMENT \"\",\n  `inputTextLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl8` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl9` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl10` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl11` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl12` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl13` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl14` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl15` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl16` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl17` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl18` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl19` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl20` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputDateLbl1` date NULL COMMENT \"\",\n  `inputDateLbl2` date NULL COMMENT \"\",\n  `inputDateLbl3` date NULL COMMENT \"\",\n  `inputDateLbl4` date NULL COMMENT \"\",\n  `inputDateLbl5` date NULL COMMENT \"\",\n  `inputDateLbl6` date NULL COMMENT \"\",\n  `inputDateLbl7` date NULL COMMENT \"\",\n  `inputDateLbl8` date NULL COMMENT \"\",\n  `inputDateLbl9` date NULL COMMENT \"\",\n  `inputDateLbl10` date NULL COMMENT \"\",\n  `inputDateLbl11` date NULL COMMENT \"\",\n  `inputDateLbl12` date NULL COMMENT \"\",\n  `inputDateLbl13` date NULL COMMENT \"\",\n  `inputDateLbl14` date NULL COMMENT \"\",\n  `inputDateLbl15` date NULL COMMENT \"\",\n  `inputDateLbl16` date NULL COMMENT \"\",\n  `inputDateLbl17` date NULL COMMENT \"\",\n  `inputDateLbl18` date NULL COMMENT \"\",\n  `inputDateLbl19` date NULL COMMENT \"\",\n  `inputDateLbl20` date NULL COMMENT \"\",\n  `inputDateTimeLbl1` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl2` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl3` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl4` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl5` datetime NULL COMMENT \"\",\n  `inputDropDownLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl3` varchar(65533) NULL COMMENT \"\",\n  `created_by` varchar(65533) NULL COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `modified_by` datetime NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_opportunities": "CREATE TABLE `crm_opportunities` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `profileid` int(11) NOT NULL COMMENT \"\",\n  `customer_id2` varchar(65533) NOT NULL COMMENT \"\",\n  `title` varchar(65533) NOT NULL COMMENT \"\",\n  `description` varchar(65533) NULL COMMENT \"\",\n  `deal_date` varchar(65533) NOT NULL COMMENT \"\",\n  `amount` decimal64(15, 2) NULL DEFAULT \"0.00\" COMMENT \"\",\n  `status` int(11) NOT NULL DEFAULT \"0\" COMMENT \"crm_status.id\",\n  `category` int(11) NOT NULL COMMENT \"\",\n  `category_list` varchar(65533) NULL COMMENT \"crm_category.id as json format\",\n  `date` varchar(65533) NOT NULL COMMENT \"\",\n  `modifieddate` datetime NOT NULL COMMENT \"\",\n  `isactive` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `refid` varchar(65533) NULL COMMENT \"unique running no\",\n  `assigned_to` varchar(65533) NULL COMMENT \"green assign\",\n  `assigned_to_view` varchar(65533) NULL COMMENT \"green view\",\n  `assigned_to_edit` varchar(65533) NULL COMMENT \"NOT USED ANYMORE\",\n  `assigned_to_chosen` varchar(65533) NULL COMMENT \"NOT USED ANYMORE\",\n  `assigned_to_count` varchar(65533) NULL COMMENT \"grey view\",\n  `alert_assigned` varchar(65533) NULL COMMENT \"deal alert for user\",\n  `referenceid` varchar(65533) NULL COMMENT \"link to crm_reference\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `assign_child` varchar(65533) NULL COMMENT \"\",\n  `deal_category_id` int(11) NULL COMMENT \"\",\n  `customer_id` bigint(20) NULL COMMENT \"\",\n  `deal_end_datetime` datetime NULL COMMENT \"\",\n  `deal_start_datetime` datetime NULL COMMENT \"\",\n  `deal_completed_date` datetime NULL COMMENT \"\",\n  `deal_status_change_date` datetime NULL COMMENT \"\",\n  `deal_completed_by` bigint(20) NULL COMMENT \"\",\n  `def_ind` bigint(20) NULL DEFAULT \"0\" COMMENT \"\",\n  `collection_balance` decimal64(15, 2) NULL DEFAULT \"0.00\" COMMENT \"\",\n  `old_status` varchar(65533) NULL COMMENT \"\",\n  `last_alert_datetime` datetime NULL COMMENT \"\",\n  `last_comment_datetime` datetime NULL COMMENT \"\",\n  `collection` decimal64(15, 2) NULL DEFAULT \"0.00\" COMMENT \"\",\n  `unique_comment_categories` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 2 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_reference": "CREATE TABLE `crm_reference` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `name` varchar(65533) NULL COMMENT \"\",\n  `creatorid` int(11) NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `isactive` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `seq_no` varchar(65533) NULL COMMENT \"\",\n  `create_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `status` int(11) NULL COMMENT \"\",\n  `category` int(11) NULL COMMENT \"\",\n  `startdate` datetime NULL COMMENT \"\",\n  `enddate` datetime NULL COMMENT \"\",\n  `inputDefText1` varchar(65533) NULL COMMENT \"\",\n  `inputDefText2` varchar(65533) NULL COMMENT \"\",\n  `inputDefDropDown1` varchar(65533) NULL COMMENT \"\",\n  `inputDefDropDown2` varchar(65533) NULL COMMENT \"\",\n  `inputDefMulCheckBox1` varchar(65533) NULL COMMENT \"\",\n  `inputDefMulCheckBox2` varchar(65533) NULL COMMENT \"\",\n  `inputDefAttachment1` varchar(65533) NULL COMMENT \"\",\n  `inputDefAttachment2` varchar(65533) NULL COMMENT \"\",\n  `inputDefDate1` datetime NULL COMMENT \"\",\n  `last_comment_datetime` datetime NULL COMMENT \"\",\n  `unique_comment_categories` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_reference_dynamic_data": "CREATE TABLE `crm_reference_dynamic_data` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `profile_id` int(11) NULL COMMENT \"\",\n  `reference_id` int(11) NULL COMMENT \"\",\n  `template_id` int(11) NULL COMMENT \"\",\n  `inputTextLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl8` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl9` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl10` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl11` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl12` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl13` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl14` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl15` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl16` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl17` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl18` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl19` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl20` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl21` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl22` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl23` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl24` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl25` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl26` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl27` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl28` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl29` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl30` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl31` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl32` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl33` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl34` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl35` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl36` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl37` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl38` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl39` varchar(65533) NULL COMMENT \"\",\n  `inputTextLbl40` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputTextareaLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl8` varchar(65533) NULL COMMENT \"\",\n  `inputNumberLbl9` varchar(65533) NULL COMMENT \"\",\n  `inputDateLbl1` date NULL COMMENT \"\",\n  `inputDateLbl2` date NULL COMMENT \"\",\n  `inputDateLbl3` date NULL COMMENT \"\",\n  `inputDateLbl4` date NULL COMMENT \"\",\n  `inputDateLbl5` date NULL COMMENT \"\",\n  `inputDateTimeLbl1` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl2` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl3` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl4` datetime NULL COMMENT \"\",\n  `inputDateTimeLbl5` datetime NULL COMMENT \"\",\n  `inputDropDownLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl8` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl9` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl10` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl11` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl12` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl13` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl14` varchar(65533) NULL COMMENT \"\",\n  `inputDropDownLbl15` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl3` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl4` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl5` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl6` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl7` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl8` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl9` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl10` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl11` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl12` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl13` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl14` varchar(65533) NULL COMMENT \"\",\n  `inputMulCheckBoxLbl15` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl1` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl2` varchar(65533) NULL COMMENT \"\",\n  `inputAttachmentLbl3` varchar(65533) NULL COMMENT \"\",\n  `created_by` varchar(65533) NULL COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `modified_by` datetime NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_status": "CREATE TABLE `crm_status` (\n  `id` int(11) NOT NULL COMMENT \"\",\n  `parentid` int(11) NULL COMMENT \"\",\n  `name` varchar(65533) NOT NULL COMMENT \"\",\n  `type` varchar(65533) NOT NULL COMMENT \"\",\n  `isactive` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `ishide` varchar(65533) NULL COMMENT \"\",\n  `color` varchar(65533) NULL COMMENT \"\",\n  `sort` int(11) NULL COMMENT \"\",\n  `user_edit` int(11) NOT NULL DEFAULT \"1\" COMMENT \"\",\n  `customer_edit` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `status_change` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `df_creation` int(11) NULL DEFAULT \"2\" COMMENT \"\",\n  `type_original` varchar(65533) NULL COMMENT \"\",\n  `send_type` varchar(65533) NULL DEFAULT \"PDF\u0026EMAIL\" COMMENT \"\",\n  `company_parentid` bigint(20) NULL COMMENT \"\",\n  `code` varchar(65533) NULL COMMENT \"\",\n  `send_pf_email` varchar(65533) NOT NULL DEFAULT \"Enable\" COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);",
    "staging.crm_user_permissions": "CREATE TABLE `crm_user_permissions` (\n  `id` bigint(20) NOT NULL COMMENT \"\",\n  `parentid` bigint(20) NULL COMMENT \"\",\n  `profileid` bigint(20) NULL COMMENT \"\",\n  `type` varchar(65533) NULL COMMENT \"customer,deal,activity\",\n  `current_permission` bigint(20) NULL COMMENT \"\",\n  `child_permission` largeint(40) NULL COMMENT \"\",\n  `no_of_child_view` bigint(20) NULL COMMENT \"\",\n  `ref_id` bigint(20) NULL COMMENT \"customer.id, oppo.id, activity.id\",\n  `status` int(11) NULL DEFAULT \"1\" COMMENT \"\",\n  `created_datetime` datetime NULL COMMENT \"\",\n  `modified_datetime` datetime NULL COMMENT \"\",\n  `created_by` bigint(20) NULL COMMENT \"\",\n  `modified_by` bigint(20) NULL COMMENT \"\",\n  `mig_ind` int(11) NULL DEFAULT \"0\" COMMENT \"\",\n  `start_datetime` datetime NULL COMMENT \"\",\n  `end_datetime` datetime NULL COMMENT \"\",\n  `deal_id` bigint(20) NULL COMMENT \"\",\n  `customer_id` bigint(20) NULL COMMENT \"\",\n  `type_original` varchar(65533) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nPRIMARY KEY(`id`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`id`) BUCKETS 9 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\",\n\"compression\" \u003d \"LZ4\"\n);"
  },
  "table_row_count": {
    "staging.crm_category": {
      "crm_category": 44686
    },
    "staging.crm_customer_details": {
      "crm_customer_details": 51640
    },
    "staging.crm_status": {
      "crm_status": 21078
    },
    "staging.crm_deal_dynamic_data": {
      "crm_deal_dynamic_data": 7345
    },
    "staging.crm_reference_dynamic_data": {
      "crm_reference_dynamic_data": 27390
    },
    "staging.crm_activity": {
      "crm_activity": 128152
    },
    "staging.crm_opportunities": {
      "crm_opportunities": 25286
    },
    "staging.crm_customer_dynamic_data": {
      "crm_customer_dynamic_data": 13213
    },
    "staging.crm_reference": {
      "crm_reference": 70038
    },
    "staging.crm_activity_asset_mapping": {
      "crm_activity_asset_mapping": 540246
    },
    "staging.crm_activity_dynamic_data": {
      "crm_activity_dynamic_data": 98949
    }
  },
  "session_variables": "{\"enable_show_all_variables\":false,\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"transmission_encode_level\":7,\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"enable_resource_group_v2\":true,\"new_planner_optimize_timeout\":3000,\"enable_realtime_mv\":false,\"enable_adaptive_sink_dop\":true,\"force_schedule_local\":false,\"enable_profile\":false,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"enable_local_shuffle_agg\":true,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"nested_mv_rewrite_max_level\":3,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"profile_limit_fold\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"cbo_max_reorder_node_use_dp\":10,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"query_cache_agg_cardinality_limit\":5000000,\"query_timeout\":300,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"cboPushDownAggregateMode_v1\":-1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":true,\"interpolate_passthrough\":true,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"broadcast_right_table_scale_factor\":10,\"disable_streaming_preaggregations\":false,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"enable_scan_block_cache\":false,\"div_precision_increment\":4,\"auto_increment_increment\":1,\"sql_mode_v2\":32,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"hive_partition_stats_sample_size\":3000,\"enable_optimizer_trace_log\":false,\"enable_mv_planner\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"profile_timeout\":2,\"pipeline_dop\":0,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"query_cache_hot_partition_num\":3,\"query_cache_type\":0,\"disable_colocate_join\":false,\"query_cache_entry_max_rows\":409600,\"max_pushdown_conditions_per_column\":-1,\"enable_materialized_view_union_rewrite\":true,\"enable_exchange_pass_through\":true,\"query_cache_entry_max_bytes\":4194304,\"innodb_read_only\":true,\"enable_exchange_perf\":false,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_query_cache\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"max_allowed_packet\":1048576,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Etc/UTC\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}",
  "column_statistics": {
    "staging.crm_category": {
      "id": "[1.0, 47207.0, 0.0, 4.0, 44679.0] ESTIMATE"
    },
    "staging.crm_customer_details": {
      "id": "[1.0, 55871.0, 0.0, 4.0, 52070.0] ESTIMATE"
    },
    "staging.crm_status": {
      "id": "[1.0, 22247.0, 0.0, 4.0, 21009.0] ESTIMATE"
    },
    "staging.crm_deal_dynamic_data": {
      "oppor_id": "[100.0, 25805.0, 0.0, 4.0, 7186.0] ESTIMATE"
    },
    "staging.crm_reference_dynamic_data": {
      "reference_id": "[68.0, 75092.0, 3.650967506389193E-5, 4.0, 26938.0] ESTIMATE"
    },
    "staging.crm_activity": {
      "seq_no": "[-Infinity, Infinity, 0.05373390557939914, 4.73082325399922, 59610.0] ESTIMATE",
      "datetime": "[0.0, 1.9425852E9, 0.0, 8.0, 32477.0] ESTIMATE",
      "end_datetime": "[0.0, 1.9426104E9, 0.0, 8.0, 33542.0] ESTIMATE",
      "isactive": "[0.0, 1.0, 0.0, 4.0, 2.0] ESTIMATE",
      "id": "[3.0, 128763.0, 0.0, 4.0, 127070.0] ESTIMATE",
      "customer_id": "[0.0, 55870.0, 0.08578228638314475, 8.0, 7782.0] ESTIMATE",
      "category": "[0.0, 47172.0, 8.583690987124464E-5, 8.0, 2440.0] ESTIMATE",
      "opporid": "[0.0, 113772.0, 0.0021615294576667965, 8.0, 13675.0] ESTIMATE",
      "parentid": "[6.0, 2687.0, 0.0, 4.0, 345.0] ESTIMATE",
      "status": "[0.0, 22236.0, 0.0, 8.0, 1543.0] ESTIMATE"
    },
    "staging.crm_opportunities": {
      "id": "[11.0, 25808.0, 0.0, 4.0, 24983.0] ESTIMATE"
    },
    "staging.crm_customer_dynamic_data": {
      "customer_id": "[0.0, 55871.0, 7.568876778686043E-5, 4.0, 13223.0] ESTIMATE"
    },
    "staging.crm_reference": {
      "id": "[68.0, 75092.0, 0.0, 4.0, 70191.0] ESTIMATE",
      "category": "[0.0, 47179.0, 1.2850167052171679E-4, 4.0, 662.0] ESTIMATE",
      "parentid": "[6.0, 2687.0, 1.4277963391301864E-5, 4.0, 223.0] ESTIMATE"
    },
    "staging.crm_activity_asset_mapping": {
      "activity_id": "[15363.0, 128762.0, 0.0, 4.0, 49843.0] ESTIMATE",
      "asset_id": "[0.0, 75085.0, 0.0, 4.0, 4977.0] ESTIMATE"
    },
    "staging.crm_activity_dynamic_data": {
      "activity_id": "[779.0, 128763.0, 6.0638523654077434E-5, 4.0, 98347.0] ESTIMATE"
    }
  },
  "be_number": 3,
  "be_core_stat": {
    "numOfHardwareCoresPerBe": "{\"10003\":4,\"10004\":4,\"10005\":4}",
    "cachedAvgNumOfHardwareCores": 4
  },
  "exception": [],
  "version": "UNKNOWN",
  "commit_version": "db1716d7b"
}